﻿-- =============================================
-- Script Template
-- =============================================

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

/****Create Default Records ****/
PRINT 'INSERTING DEFAULT DATA .... [Sys_RoleActivity]'
GO


INSERT [Sys_RoleActivity] ([RolerKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 1, N'SYSSPRADM', N'System Super Admin', N'DFLT_BLG_CRT', N'Create Default Blogs', GETDATE(), GETDATE(), N'-1', N'-1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RolerKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 2, N'SYSSPRADM', N'System Super Admin', N'DFLT_BLG_RTV', N'Retrieve Default Blog', GETDATE(), GETDATE(), N'-1', N'-1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RolerKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 3, N'SYSSPRADM', N'System Super Admin', N'DFLT_BLG_UPD', N'Update Default Blogs', GETDATE(), GETDATE(), N'-1', N'-1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RolerKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 4, N'SYSSPRADM', N'System Super Admin', N'DFLT_BLG_DEL', N'Delete Default Blog', GETDATE(), GETDATE(), N'-1', N'-1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RolerKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 5, N'SYSSPRADM', N'System Super Admin', N'DFLT_DNL_CRT', N'Create Default Downloadable Content', GETDATE(), GETDATE(), N'-1', N'-1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RolerKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 6, N'SYSSPRADM', N'System Super Admin', N'DFLT_DNL_RTV', N'Retrieve Default Downloadable Content', GETDATE(), GETDATE(), N'-1', N'-1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RolerKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 7, N'SYSSPRADM', N'System Super Admin', N'DFLT_DNL_UPD', N'Update Default Downloadable Contents', GETDATE(), GETDATE(), N'-1', N'-1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RolerKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, 8, N'SYSSPRADM', N'System Super Admin', N'DFLT_DNL_DEL', N'Delete Default Downloadable Content', GETDATE(), GETDATE(), N'-1', N'-1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RolerKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 1, N'SYSADMIN', N'System Admin', N'DFLT_BLG_CRT', N'Create Default Blogs', GETDATE(), GETDATE(), N'-1', N'-1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RolerKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 2, N'SYSADMIN', N'System Admin', N'DFLT_BLG_RTV', N'Retrieve Default Blog', GETDATE(), GETDATE(), N'-1', N'-1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RolerKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 3, N'SYSADMIN', N'System Admin', N'DFLT_BLG_UPD', N'Update Default Blogs', GETDATE(), GETDATE(), N'-1', N'-1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RolerKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 4, N'SYSADMIN', N'System Admin', N'DFLT_BLG_DEL', N'Delete Default Blog', GETDATE(), GETDATE(), N'-1', N'-1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RolerKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 5, N'SYSADMIN', N'System Admin', N'DFLT_DNL_CRT', N'Create Default Downloadable Content', GETDATE(), GETDATE(), N'-1', N'-1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RolerKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 6, N'SYSADMIN', N'System Admin', N'DFLT_DNL_RTV', N'Retrieve Default Downloadable Content', GETDATE(), GETDATE(), N'-1', N'-1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RolerKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 7, N'SYSADMIN', N'System Admin', N'DFLT_DNL_UPD', N'Update Default Downloadable Contents', GETDATE(), GETDATE(), N'-1', N'-1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RolerKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 8, N'SYSADMIN', N'System Admin', N'DFLT_DNL_DEL', N'Delete Default Downloadable Content', GETDATE(), GETDATE(), N'-1', N'-1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RolerKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (3, 9, N'SYSREGUSR', N'System Registered User', N'BLG_CRT', N'Create Blogs', GETDATE(), GETDATE(), N'-1', N'-1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RolerKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (3, 10, N'SYSREGUSR', N'System Registered User', N'BLG_RTV', N'Retrieve Blogs', GETDATE(), GETDATE(), N'-1', N'-1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RolerKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (3, 11, N'SYSREGUSR', N'System Registered User', N'BLG_UPD_OWN', N'Update Self-created  Blogs', GETDATE(), GETDATE(), N'-1', N'-1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RolerKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (3, 12, N'SYSREGUSR', N'System Registered User', N'BLG_DEL_OWN', N'Delete Self-created Blogs', GETDATE(), GETDATE(), N'-1', N'-1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RolerKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (3, 13, N'SYSREGUSR', N'System Registered User', N'DNL_CRT', N'Create Downloadable Content', GETDATE(), GETDATE(), N'-1', N'-1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RolerKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (3, 14, N'SYSREGUSR', N'System Registered User', N'DNL_RTV', N'Retrieve Downloadable Contents', GETDATE(), GETDATE(), N'-1', N'-1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RolerKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (3, 15, N'SYSREGUSR', N'System Registered User', N'DNL_UPD_OWN', N'Update Self-created Downloadable Contents', GETDATE(), GETDATE(), N'-1', N'-1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_RoleActivity] ([RolerKey], [RoleActivityKey], [RoleCode], [RoleName], [ActivityCode], [ActivityName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (3, 16, N'SYSREGUSR', N'System Registered User', N'DNL_DEL_OWN', N'Delete Self-created Downloadable Contents', GETDATE(), GETDATE(), N'-1', N'-1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

